from public.action import *
from public.business import *
from public.testData import *
from public.tools import *

testCase = "DBshop025_商品咨询回复"
#1.安装pymysql 安装0.10版本,它跟python3.4兼容
import pymysql
#2.创建一个数据库的连接对象
connection=pymysql.connect(host="127.0.0.1",user="root",password="root",database="dbshop",charset="utf8")
#3.创建一个游标对象用于执行SQL语句
cursor=connection.cursor()
#4.执行sql语句
cursor.execute("DELETE FROM dbshop.dbshop_goods_ask;")
cursor.execute("commit;")
#5.断开数据库的连接
connection.close()